sql="select * from (select username,sum(shul) as shul from jingyin group by jingsh) order by shul "

来源：百度知道编辑：UC知道时间：2024/05/21 15:08:06

sql="select * from (select username,sum(shul) as shul from jingyin group by jingsh) order by shul "
asp ACCESS 出错
数据库

除了"带我信乐"说的错误外,还有一处错误,就是: 子查询中的username没有使用聚合函数或加入group by 列表.
如果要改的话,需要知道表jingyin的结构,和若干条数据.

select * from (select username,sum(shul) as shul from jingyin group by jingsh)
要加个别名就行了
select * from (select username,sum(shul) as shul from jingyin group by jingsh) AS T
order by shul

sql="select * from user" sql="select * from问题 sql="select * from sg where sql="select * from……" sql = "Select top 5 * from news" sql="select top 5 news.* from 问题 sql="select * from 表名 where 字段名=' "& document.Form.Select.value" ' " sql = "Select * From [userinfo] Where userid = '"&userid&"'" ； sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei") sql="select * from BigClass where typeid="&typeid&" order by bigclassorder"